﻿CREATE TABLE [dbo].[Goods]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [GoodsName] VARCHAR(200) NULL, 
    [LogoUrl] VARCHAR(200) NULL, 
    [Total] INT NOT NULL, 
    [Remainder] INT NOT NULL , 
    [Price] DECIMAL(5, 2) NULL, 
    [Desc] VARCHAR(2000) NULL, 
    [CreateDate] DATETIME NOT NULL, 
    [UpdateDate] DATETIME NOT NULL, 
    [State] BIT NOT NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = 'GoodsName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品log图片',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'LogoUrl'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品历史总计数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'Total'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品剩余数量，可售数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'Remainder'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'Price'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'是否可用 :1=可用；2=不可用',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'State'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品描述',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Goods',
    @level2type = N'COLUMN',
    @level2name = N'Desc'